Search results for query: *

[smile]George, You were correct the connection string seems to have fixed our issue. We are now using this string: conn.ConnectionString = "Provider=SQLNCLI.1;Persist Security Info=False;User ID=XX;Password=XXXXXXX;Initial Catalog=giftcard;Data Source=XX.X.X.XX,1433" Thank you very much for...

George, I also am not seeing the Network Library. I have : Connect Timeout Data Source Extended Properties General Timeout Initial Catalog Locale Identifier Location Mode Password Persist Security Info User ID Robert

George, The "Microsoft OLEDB Provider for SQL Server" is not on the list. There is a "Microsoft OLEDB Provider for ODBC Drivers" A few other options are: SQL Native Client & SQL Server Replication OLE DB Provider for DTS. Robert

George, In the TCP/IP Properties - under IP1; IP2; & IPAll The TCP Dynamic Ports is empty The TCP Port has 1433 I will see if we can get the program to work with the IP address. I will also look into the sizing of the DB next, and update this thread. Thank you, Robert

George, Sorry, I thought the attachment would be uploaded. I have attached what the data that was in that file: FIELDS RECORD1 RECORD2 Name: giftcard-test giftcard-test_log Fileid: 1 2 Filename...

We tried to replace the server name with the IP address, but we were not able to get that to work. I checked the protocols for the TCP/IP and it is enabled and the Dynamic Port value is empty. The results of the query you wanted are in the file below We have not been able to test the re-write...

Set conn = New ADODB.Connection conn.ConnectionString = "DSN=xxxxxxxx-xxx;" & _ "DATABASE=xxxxxxxx;uid=xxxxxxxx;pwd=xxxxxxxx;" sqlServer = 1 conn.Open We use the same connect statement for our bulk loads and select statements and they work without issues. We have only...

We are running a scheduled task that will update a database each day. The update can have anywhere between 2000 and 8000 records. When we run this process, it is stopping part way through. This process was initially running on an Informix DB and has been moved to a 2005SQL DB. Since we have...