SQL Server 2008 (page 2) Questionssubmit your own question

Hello, I would like to create a database and add tables from VBA. Can someone help me ? I have tried the following code with no sucess :( Dim str Dim conn, rst Set conn = CreateObject("ADODB.Connection")

Hi! I'm trying to create a test DB in SQL Server 2008, using Visual Basic 2010 Express. I'm failing each time--no message, just nothing shows up. Is it my connection string? Private Sub createDB()

Hi all , I have two servers in the same domain name , I installed a WebService on IIS one server,, the webservice read data from sql server 2008 database stored on another server ,

I am using sqlserver 2008 and .net Framework 4.5 my connectionstring as below: enter code here <connectionStrings> <add name="ConnectionString" connectionString="data source=(local); Database:bongah; User id=myusername; Password=my password"/>

I am creating a windows application.using sql server 2008. I am getting connection string problem while connecting to .mdf file which is in this location c\folder\file.mdf.

Hi All, Im wanting to know if there is a way I can point our connection string to a custom application/utility. The reason being we currently are running an asp mvc LOB application which is having so

Here's the setup: MS Access has a linked table to SQL Server. SQL Server has a password on it. Trying to use Excel VBA to query this linked table in Access, but I can't get the connection string co

Hi, I have a .NET application which is hosted on a web server and an MSSQL db hosted on a different server. As part of the security checklist, I am not supposed to mention the db credentials (conne

I have tried to connect to the remote computer using this string = 'Server=tcp:SERVER,1433;Database=TBSDB.mdf;Integrated Security=True;Network Library=dbmssocn;Connect Timeout=30;User Instance=True'

Using SQL Server 2012, what is the best data type to use for storing date time values. DateTime or DateTime2?

I am new with VB. I got now the Visual Studio 2010. I've never used it before. I need the following: I need a login form, which is using an ms sql server database, in which I stored usernames and pas

I need a connection string between an old but necessary VB6 (current Service Pack) program and SQL Server 2008 R2. Since the VB6 program will not run on W7, it runs on an XP box, SQL Server is runnin

I need to deploy an SQL Server 2008 R2 Express Edition database and tables,store-procedure with my app form C# by Visual Studio 2010 project using setup project. Ii create setup of my project but get

I got a LAN (non-domain) nature. One of the PC of Widnows 7 Pro (32bit) is hosting SQL Server Express 2008 and Custom Made Application which is using the SQL server. Now the other PC (Vista Business)

Hello Dear Friends i need a help with the connection string, im using visual studio 2010 and sql server 2008. I create a exe file for my application, so that i can install it in another laptop, after

Hi there, I am a member of this forum. I am interested to learn SQL server, now i own 2008 standard edition version. Just got it downloaded from website. I do not know anything about this. This is a

I am trying to create a SQL 2008 connection from VBscript using Windows Authentication and I am getting the error "login failed" for the below string. Any sort of help is much appreciated. strConnect

I have made at database at SQL 2008. I have added the database at my Visual basic project and prepare my application. While I am adding records from the FORMS I have made at VB, it is saving at the da

I have a problem with connection string for SQL Server 2008. I think it is connection string. It give me error 26 when i try to login. This is the connection string Data Source=192.168.0.1;Initial C

Hi all, I am trying to figure out how to create my connection string so that I can use current logged on account for authentication with my remote SQL server. Currently I can connect to my SQL server

i know the remote server's address like 114.120.124.112,the login name to the server is ,for example, test,password is test_1.there is a database named testDatabase in the server.there is no password

I have a SQL database that I am trying to access from a web server. I created an ODBC connection and it works just fine, but when I try to connect from my script using the DSN=Datasource option, I g