Delay Instantiating COM Object On Remote Server
System consist of COM Component Hosted on the Remote M/c
of Configuration Win2000 Server with Service Pack 2.
Client is Visual basic in Win2000 Professional and Connectivity between client and server is via WAN When try to instantiate Object using
CREATEOBJECT(Objectname,ServerName)
there Substiantial time lag in object creation.Kindly help to how speed up object creation as it is affection application performance badly.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Trouble Connecting From .NET 2.0 App On Win2000 Server Client To Remote SQL Server 2005 DB
Hi,
Has anyone experienced similar problems trying to connect under the stated configuration? Were you able to resolve?
This looks like some type of security or permissions issue on the client side but I don't know where to start looking. The login is correct and I don't have any issues when the client is XPSP2.
Additional info:
The Windows 2000 Server client is running SP4.
The 'Data Link' application used to configure the connection string from the client tests successfully.
Can't even connect as Administrator from the client.
Any guidance would be greatly appreciated.
Scott
Connecting To A Remote Server Through A Proxy Server
Hi,
Let's say that I have two Cient and Server application
running on two separate machines on the internet. If the port that the Server is listening on port 8123, how can I use the Client and connect to the Server if the client is behind a proxy server. If you have or you can direct me to
a good example please contact me.
Win2000, IIS And SQL Server For Remote Server Access
Hi Guys,
The hammer has fallen - the project I'm working on has gone belly up and I really, really need some help! Basically, our system is due to go live some three months before its due-date. (I bet this sounds familar to some of you).
Anyway, the system require remote server database access (which will be available on the web). At the moment, we've been developing in an enclosed environment using a Win NT server and RDS linking to Access. However, the intention has been to...
Move to SQL Server 2000 (for the remote database access) - With the intention of moving to XML Data Services thingy when we move to .Net later on
Move to a Win2000 server, using IIS HTTP / FTP Access
My problem is locking all this server-side stuff down, e.g. configuration of server, security of the IIS server, security of the SQL server and anything thing you top guys can point out. What I'm after is any kind of articles, advice, tit bits, etc. re: configuring the above on a Win2000 server, IIS and SQL server.
Anything - literally anything that can point me in the right direction / expedite my baptism of fire are greatly appreciated.
Drydo
improvise, overcome, go home
Microsoft MVP Visual Basic 2004, 2005, 2006, 2007 & 2008
Check out Drydo's Blog for infrequent, but bizarre code samples.
Remote Object...
Hi,
Application a.exe has a form and a listview on it.
From a VB project, how do I do refer to that listview as an object to get it's content (I can get hwnd and classname of that form and that listview)?
Remote Server
Hi all, I'm a newbie with a newbie question. I have created a Remote ActiveX EXE which simply sends messages to registered clients. How I did this was I created a Multiuse class which, when created, registers itself in a PublicNotCreatable class. The PublicNotCreatable class stores references of the multiuse classes. After registering the ActiveX EXE from a remote computer, I run a client (StandAlone EXE) which creates the MultiUse Class.
What I would like to know is there any way of a remote
PC not creating the ActiveX EXE as a proxy but rather running it from the remote PC. If I can get the ActiveX EXE to do this, then I can send messages from one PC to another. My objective is not to simply send messages from one PC to another but rather to call functions.
Am I going about it in the wrong way? I look forward to hearing from someone, anyone! soon
Regards
Ezz
Remote Server
Hello All,
I need to sync databases. One database is present on a local PC and other database is present at a Remote server (could be a internet service provider host server), of which the IP address is known. How to i bring data from this remote server to the desired destination using ADO
Thanks in Advance
Tushar
Plz mail me at
jtushar@pisoftek.com
tusharjain77@rediffmail.com
Detecting Remote Server
at work we have a bit of software that uses our intranet to display caller id information from out phone system, I know it monitors port number 5891, but I can't find out what the address of the server that it's connected to, I want to write my own version of caller id and if I knew where to connect to I could, is there anyway of finding out by writing something?
Remote Server Connection.
Hi. I have this question and I donīt know if this is the right place to post it. Here it goes:
First of all I pay my bills developing vertical systems of any kind most of them in vb6 and access with CRW.
If have to develope a software for the lottery market which must be online. every point on sale must be connected real time with the server where will be located the database. The point of sale sofware must check some data on the server and then sale the selected lottery number and store it on the server. The point of sale can WIN95,98,xp, etc. If the connection fail the sale can not be performed.
and now the question: What are the tools and/or controls and/or commands to have an online server via INTERNET, or by phone line? I hope the question is clear.
Filelistbox Remote Server
Hi i have the following code that i need to addapt to populate a filelistbox with the list of files on the server. i am a real newb at this and i didnt write this code my self i managed to get it from one of the sites can any one post a modeifaction to get the list of files into the filelistbox please please please
Code as follows
Option Explicit
Private Declare Function InternetOpen Lib "wininet.dll" Alias "InternetOpenA" (ByVal sAgent As String, ByVal lAccessType As Long, ByVal sProxyName As String, ByVal sProxyBypass As String, ByVal lFlags As Long) As Long
Private Declare Function InternetConnect Lib "wininet.dll" Alias "InternetConnectA" (ByVal hInternetSession As Long, ByVal sServerName As String, ByVal nServerPort As Integer, ByVal sUserName As String, ByVal sPassword As String, ByVal lService As Long, ByVal lFlags As Long, ByVal lContext As Long) As Long
Private Declare Function FtpGetCurrentDirectory Lib "wininet.dll" Alias "FtpGetCurrentDirectoryA" (ByVal hFtpSession As Long, ByVal lpszCurrentDirectory As String, lpdwCurrentDirectory As Long) As Long
Private Declare Function FtpSetCurrentDirectory Lib "wininet.dll" Alias "FtpSetCurrentDirectoryA" (ByVal hFtpSession As Long, ByVal lpszDirectory As String) As Boolean
Private Declare Function FtpPutFile Lib "wininet.dll" Alias "FtpPutFileA" (ByVal hConnect As Long, ByVal lpszLocalFile As String, ByVal lpszNewRemoteFile As String, ByVal dwFlags As Long, ByVal dwContext As Long) As Boolean
Private Declare Function FtpGetFile Lib "wininet.dll" Alias "FtpGetFileA" _
(ByVal hFtpSession As Long, ByVal lpszRemoteFile As String, _
ByVal lpszNewFile As String, ByVal fFailIfExists As Boolean, _
ByVal dwFlagsAndAttributes As Long, ByVal dwFlags As Long, _
ByVal dwContext As Long) As Boolean
Private Declare Function InternetCloseHandle Lib "wininet.dll" (ByVal hInet As Long) As Integer
Const INTERNET_OPEN_TYPE_PRECONFIG = 0 ' use registry configuration
Const INTERNET_DEFAULT_FTP_PORT = 21 ' default for FTP servers
Const INTERNET_SERVICE_FTP = 1
Const PassiveConnection As Boolean = True
Const INTERNET_FLAG_PASSIVE = &H8000000 ' used for FTP connections
Const MAX_PATH = 260
Const FTP_TRANSFER_TYPE_UNKNOWN = &H0
Private Sub downloadFile_Click()
Dim hConnection As Long, hOpen As Long, sOrgPath As String
'open an internet connection
hOpen = InternetOpen("API-Guide sample program", INTERNET_OPEN_TYPE_PRECONFIG, vbNullString, vbNullString, 0)
'connect to the FTP server
hConnection = InternetConnect(hOpen, "82.192.78.21", INTERNET_DEFAULT_FTP_PORT, "SOF2", "fockoff", INTERNET_SERVICE_FTP, IIf(PassiveConnection, INTERNET_FLAG_PASSIVE, 0), 0)
'create a buffer to store the original directory
sOrgPath = String(MAX_PATH, 0)
'get the directory
FtpGetCurrentDirectory hConnection, sOrgPath, Len(sOrgPath)
'set the current directory to 'root/httpdocs'
FtpSetCurrentDirectory hConnection, sPath
'Now download file
Call FtpGetFile(hConnection, sFile, App.Path & "" & sFile, 0, 0, 2, 0)
'close the FTP connection
InternetCloseHandle hConnection
'close the internet connection
InternetCloseHandle hOpen
MsgBox "Complete "
end sub
thanks in advance
Remote Server Machine Is Not Available???
This post is about a permissions problem for a client/server application.
Background:
A VB6 application consisting of a client and a server component which handles data to/from SQL server 7 database.
The client program (standard EXE, and in process DLLs) connects to the server component (activeX) over a network. The client is a member of a group (GROUP-A) which is authorized to access and launch (via DCOMCONFG) the server ActiveX. Only GROUP-A has these rights (this is how we control who does use this server component which is a gateway to confidential data on the SQL).
We compiled and packaged the application. In a preliminary test we have two computers which are on a WorkGroup. We installed the server component on one computer (as well as the SQL database) and the client on the other. We can verify that the server component can launch.
We then remove all server component restrictions, i.e., we add both 'Guests' and NETWORK users to both access and launch, but when we run the application we get the error:
"Permission Denied."
If we first start the server component and then run the client side code we get a different error.
"Remote server machine does not exist or is not available."
That tells me that it is reaching the server component but getting stopped because of permissions.... but I eased the permissions... so what is going on?
medref
What Remote Server Machine?
I am writing a program that generates a report into a word document. It creates a Word document, opens it up and shows it, then fills in the data. It is up to the user to save it if they like, or just close it and throw it away. It works great the first time, but if I close that report and try to generate a second report without restarting my program I get the following error message:
Quote:
The Remote Server Machine does not exist or is unavailable
If I hit debug it takes me to here in my code:
Code:
'Write the File info to word document
WordApp.ActiveWindow.ActivePane.View.Zoom.Percentage = 75
WordApp.ActiveDocument.PageSetup.Orientation = wdOrientLandscape
WordApp.Selection.Font.Size = 12
WordApp.ActiveDocument.PageSetup.LeftMargin = InchesToPoints(0.5) '<------ This is the offending line
WordApp.ActiveDocument.PageSetup.RightMargin = InchesToPoints(0.5)
If I leave the first Word window open and generate a second report it will work fine, it just doesn't like me closing the first Window produced. If I exit the program, restart it and then generate a report it works fine. I have no code in place to close the document or quit Word, I leave that up to the user, but it seems to work better if they don't close the document.
What doesn't it like about my margins?
/<evin
Remote Server Is Unavailable
Can anyone help.
I have an app that loads word in the background to check the page count.
I am getting the error:
Error 462: The remote server machine does not exist or is unavailable.
Now, this does not happen all the time and it also does not happen after successfully running its code once. (like i have seen in error threads before).
My code looks like this:
Global Module:
Option Explicit
'MS word objects
Public objword As New Word.Application
Public objDoc As New Word.Document
Public objRange As Range
Public fsoFileObj As New FileSystemObject
Public fsoFile As file
form:
Set objDoc = objword.Documents.Open(FileName:=APPConst.Review & "" & Left(lstAuthorise.Text, Trimmed) & ".doc", AddToRecentFiles:=False)
iPageCount = objDoc.ComputeStatistics(wdStatisticPages)
objDoc.Close Savechanges:=wdDoNotSaveChanges
I dont think that i have any unreferenced objects ?
Thanks
Ian.
IADsGroup On Remote Server
I am writing vb code to add a user and put that user in a local group on a remote server. The server is a web server outside of our domain. I connect to it through its IP address example:
Set cont = GetObject("WinNT://1.1.1.1,computer")
Set Group = GetObject("WinNT://1.1.1.1/administrators")
...Add New User here .....
Group.Add ("WinNT://" & sComputer & "/" & sUser)
sUser is the username.
I can create a new user account on the remote machine but when I try to add the new user to the local group I get an error that says the member does not exist.
The user is created and does exist so I don't know why I am getting this error. I have used this same code for server inside my domain and everything works fine. This must be something to do with the server being outside the domain. I don't think its a right issue or communication issue because it does create the user on the remote server, I just can't add them to the local group of that remote server.
Any suggestion greatly appreciated.
Thanks
ConnectionString Remote SQL-Server
ok I have a SQL-Server running on other PC of my LAN.
and in my Visual Basic program I write it to connect:
Code:
SQLConn.ConnectionString = "data source=//RemotePC/rhpc;initial catalog=DB;user id=xxxx;password=yyyyy"
but it is not correct.
What must write into my connectionString?
Thanks.
Need Help {Remote Control CS Server}
im an 11 year old whos just started visual basic (only just stopped using logo lol) and i need to know if theres a way to make a mouse click on the screen at (x,y) pixels while having a program run in the background. ill also need right clicks. if u know how to do this could u please post it. thx in advance
SQL Server From Remote Connection
Hi Everyone PLease Help!!
I've developed an app that stores approx. 40,000 records on a sql server. The app's performance is amazing when connected to a LAN however, when I try to run the same app and return the same 40,000 records remotely over the internet, the whole app slows to a crawl. Is there any way to improve the performance of my app. Maybe create a local DB and replicate it with the SQL server db?? or retrieve the database data on the app's startup and store the data somewhere locally until the next time a full retrieval is required?? Are there any other options?
Thanks for your help!!
SQL Server IPs: Who Is Who In Remote Connection?
Hi there,
Code:
oConn.Open "Driver={SQL Server};" & _
"Server=xxx.xxx.xxx.xxx;" & _
"Address=xxx.xxx.xxx.xxx,1433;" & _
"Network=DBMSSOCN;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"
When connecting with remote SQL Server, there is two ip addresses to pass: Server and Address. At first sight I'd deducte that "Server" would be the IP address of the server, but, if it is, why the default port 1433 is in the "Address" instead "Server"?
In summary, which IP goes in Address and which IP goes in Server?
And, for instances, when I am deploying a program if I want to emulate the server on my own computer. Where I put the IP "127.0.0.1"?
Thanks!
Remote Server Connection
I used msde locally to developp my app and now I would like to deploy it. I used this connection string to connect locally to the DB server.
Code:
CONNECTIONSTRING = "Provider=sqloledb;" & _
"Data Source=ComputerName;" & _
"Initial Catalog=ABCD;" & _
"Integrated Security=SSPI"
But now that my app is installed on an another computer on the network, I can no longer connect to the DB Server.
Here's the Connectionstring I tried.
Code:
CONNECTIONSTRING = "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=My computer id adress,1433;" & _
"Initial Catalog=ABCD;" & _
"User ID=sa;"
I don't know if the problem is the connectionString or if I need to included some run-time files into my setup.
The error I get when opening the connection is:
"[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied"
Any ideas on the problem
Thanks
Connecting To A Remote SQL Server Using VB6.
Hi.
I'm currently working on an EDMS project. Here's the set-up:
1. VB6 for Application Development.
2. SQL Server 2000 as Database.
Now, We have at least 10 workstations. 1 Workstation (PC 1) will act as the server and the others will be used to run the application. The 9 client workstations need to connect to PC 1 in order to run some user-triggered queries. How do I connect the 9 applications into the SQL server?
Also, is it possible for me to restrict the other 9 workstations of access to ANY file from PC1 using SQL Server alone? I need to be able to create some files and store it to PC1, but prevent the other users from accessing it from any other workstation than PC1. If this is not possible w/ SQL server, what software can I use instead (or it's up to the network configuration to disable the other users of accessing other files from PC1)?
Thanks.
Server Remote Connection
Hi all,
From this forum i got the connection string to connect a client to mySQL dbase using ODBC and the static IP of the server.
The server is behind a router, and i got the public IP of it from www.whatismyit.com .
Question : is this IP that i have to use on the client in order to establish a connection with the server ? (sorry my client is not yet ready to test it..)
thanks !
Connecting To Remote Server With ADO
I am trying to connect to a remote MySQL database using ADO in VB. It works when I use a dial-up connection but when I try and connect through our proxy server it gets and error stating that it cannot connect to the server. Is there anyway around this?
Remote SMTP Server
Anyone know of any code that uses a remote SMTP server to send emails? The catch is it cant have dependencies ..My goal is to make an app with an FAQ section and when they click contact it brings that up to send an email to me.
Connecting To A Remote SQL Server
I am using a DSN-less connection to connect to a remote SQL Server hosted on the Internet.
Code:
Set cn = New ADODB.Connection
cn.Open "Driver={SQL Server};" & _
"Server=" & StrSQLServerName & ";" & _
"Address=" & StrSQLServerIPAddress & ",1433;" & _
"Network=DBMSSOCN;" & _
"Database=MyDatabaseName;" & _
"Uid=" & StrSQLUserID & ";" & _
"Pwd=" & StrSQLPassword
The problem is that since the SQL server is hosted on a DHCP server, it does not have a static IP address. In such a scene where I cannot afford a static IP for an Internet-hosted SQL server, how can I change my connection string to connect to the SQL Server? What other means do I have to connect to the SQL Server?
Remote Server Machine Does Not ...
i receive the error "The remote server machine does not exist or is unavailable" when i try to open word from vb and word is allready open
-------------------------------------------------------------------------
hWnd = findwindow("OpusApp", vbNullString)
If hWnd = 0 Then
Set ObjWord = New Word.Application
Else
Set ObjWord = Word.Application <- error here
End If
--------------------------------------------------------------------
anyone?
Remote SQL 2000 Server
Hello everyone. I need to create a remote server on my SQL 2000 machine that will allow me to run stored procedures on my UNIX database.
Can anyone point me in the right direction on this?
Thanks
Connecting To A Remote SQL Server
How does a system on LAN not having a WAN IP nor available as a network resource on VPN, connected to Internet through a proxy, connect to a remote SQL Server hosting MS SQL Server 7?
Remote Server Error
I have a VB6 application that exports data to Microsoft Word XP template. Everything works perfectly the first time I use the code, but if the user attempts to go to the next record in the database and export data from that record to Word, it gives us run-time error 462 - "The remote server machine does not exist or is unavailable." The Word application opens, but the code breaks down when it is supposed to open the template. If the user shuts the application and then restarts it, the export command works properly again.
I know this has something to do with the Word app not shutting properly, but I can't figure out how to do this. I can't find the app running anywhere in the background.
Here's the code I'm using:
VB Code:
' Generates question using text in txtInq1 Dim WordApp As Word.Application Dim strText As String Dim strSampleno As String Dim strClaimno As String Dim strAuditor As String Dim strClient As String Dim strDate As Date Dim strTPA As String strText = txtInq1.Text strSampleno = txtSampleno.Text strClaimno = frmTitle.txtClaim_no_r.Text strClient = frmTitle.pnlCltname.Caption strAuditor = frmPage1.txtRev_1st.Text strDate = Now strTPA = frmPage1.pnlTPA_so_n.Caption Set WordApp = CreateObject("word.application") WordApp.Visible = True With WordApp Documents.Add Template:= _ "C:Documents and Settingsall usersTemplatesdefaultinq.dot" _ , NewTemplate:=False, DocumentType:=0 WordApp.Selection.Goto what:=wdGoToBookmark, Name:="Client" With WordApp.Selection .TypeText strClient ' Client name from frmPage1 End With WordApp.Selection.Goto what:=wdGoToBookmark, Name:="Samp" With WordApp.Selection .TypeText strSampleno 'Current record End With WordApp.Selection.Goto what:=wdGoToBookmark, Name:="Claimno" With WordApp.Selection .TypeText strClaimno 'Current claim number from frmTitle End With WordApp.Selection.Goto what:=wdGoToBookmark, Name:="Initials" With WordApp.Selection .TypeText strAuditor ' Auditor initials from frmPage1 End With WordApp.Selection.Goto what:=wdGoToBookmark, Name:="SubDate" With WordApp.Selection .TypeText Format(strDate, "short date") 'Current system date End With WordApp.Selection.Goto what:=wdGoToBookmark, Name:="TPA1" With WordApp.Selection .TypeText strTPA 'TPA name from frmPage1 End With WordApp.Selection.Goto what:=wdGoToBookmark, Name:="TPA2" With WordApp.Selection .TypeText strTPA 'TPA name from frmPage1 End With WordApp.Selection.Goto what:=wdGoToBookmark, Name:="TPA3" With WordApp.Selection .TypeText strTPA 'TPA name from frmPage1 End With WordApp.Selection.Goto what:=wdGoToBookmark, Name:="InqText" With WordApp.Selection .TypeText strText 'Text from txtInq1 End With End With Set WordApp = Nothing Exit Sub
Can anyone help with this?
Remote Server Information
Hello
I want to detect the hard disks on a remote server, and i found the function NetServerDiskEnum in the VB Help, but any example.
I want to know how many disks exist in the computer and the letter associated with each one.
Can anyboby help me?
Bye
Remote Automation Server
I want to have an unmanned PC be controlled remotely by an application on another PC. What is the best way to do this?
Anyone got any samples or tutorials they can point me to?
Connecting To Remote SQL Server...
hey i'm trying to connect from web server located in on my ISP to to the SQL server located in our office using this connection string:
Code:
cString = "Provider=sqloledb;" & _
"Data Source=x.x.x.x;" & _
"Network Library=DBMSSOCN;" & _
"Initial Catalog=database_name;" & _
"User ID=user_name;" & _
"Password=password;"
i get the following error:
Code:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBMSSOCN]General network error. Check your network documentation.
/dbconnect.asp, line 52
line 52 is my Open method od ADO Connection object.
please help
Connecting To Remote Sql Server
i want to conect to a remote sql server through the ip address
using vb .
thsi connenction to the sql server must be ip based , can any one suggest some methods???
Remote Server Transmision
I need aid for the following thing: I have an application in visual BASIC to make invoices installed in different computers. I need to transmit to a remote server the registry of each operation of invoicing whenever realize from each computer by means of Internet, anticipated thanks
Get Date From Remote Server
Is it possible to make a function that would get eh date and time from a remote server rather than from the local client?
}...the bane of my life!
http://www.fuzzyd.co.uk
Connecting To Remote Server In The Lan Using Ado
hi,
I have created an Application in VB 6.0 and SQL Server. i am using Ado.
the name of the DatabaseServer is Krishnan, the system name is Krishnan
and the Database NAme is Quiz. the connectio string i have used is
gconQuiz.Open "Driver=SQL Server;Server=KRISHNAN;Provider=sqloledb;" & _
"Database=Quiz;UID=sa;PWD=sa;Data Source=KRISHNAN"
my system is in a lan. the application runs well from the local system (it is the database server ) but the same EXe is not able to access it from the other systems in the lan.
the sql server properties is of Sql Server Authentication. still i am not able to access it.
in the lan domain groups have been created....will it affect my application...
tell me how should i overcome this problem.
Remote Connection To Sql Server
hi guys,
i am using vb6.0 and sql server2000 .
i have created an application in vb6 which uses a dsn to connect to the sql server.
now i want to install this application on a remote machine which is not physically conneceted to the network on which the sql server is present.so now how shall i get connected to this remote server using dsn????????????
thanks
satish
MailMerge - DSN On Remote Server
I have a MailMerge macro that works fine. It does however require a user dsn (called SQLRI) set up on every users pc. the code is below:
ActiveDocument.MailMerge.OpenDataSource Name:="", _
ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=wdOpenFormatAuto, Connection:= _
"DSN=SQLRI" _
, SQLStatement:="" & TheSQL & "" _
, SQLStatement1:="", _
SubType:=wdMergeSubTypeWord2000
I would like to just have 1 dsn in a shared folder on a server.... eg \servernameWordMacroSQLRI.dsn
However I cannot get this to work by replacing the connection string with:
Format:=wdOpenFormatAuto, Connection:= _
"DSN=\servernameWordMacroSQLRI" _
Does anyone know what I am doing wrong or even if this is possible? Perhaps there is a better way?
Thanks for anyhelp
Simon
Remote Connections To SQL Server
I have a stupid question. I have read the posts on connecting to a SQL Server by way of IP address, and I can get the connection string part, but the posters say "Configure your SQL Server for Remote Connection". How? I haven't been able to find a reference to it in any of my reference books. *feeling real stupid just now*
To err is human. To really foul things up requires a computer.
Faxing Via Remote FAX Server
I have an app that is running on local workstations within the Win 2000 OS which needs to send FAX's via the MS Shared FAX Server residing on a Win 2000 Server.
From a variety of postings on the net I have seen reference to using FAXCOM.DLL and FAXCOMEX.DLL COM objects but it has been somewhat confusing as to which is the appropriate COM object to use.
When I attempted to use the FAXCOM.DLL I registered it fine and I was able to
CREATEOBJECT("Faxserver.faxserver")
but I was not able to complete the CONNECT I got an OLE error.
Either I had used the wrong DLL COM Object or I had my CONNECT string syntax wrong.
Since I am not sure if posting here or within the VB Controls & ActiveX forum would be best - I will post there as well. I apologize if this is not appropriate.
Any advice or suggestions you might have will be greatly appreciated.
Thanks,
JRB-Bldr
Remote MySQL Server
Hi gurus,
I've been trying to connect to remote MySQL Server but VB returns error:
Cannot connect to MySQL server on 'www.mysite.com' (10060)...
A few days ago I read that when connecting it's possible to specify server address in www.mysite.com format. I tried that but also tried to specify IP address.... doen't seem to work....
Anyone know what may cause this problem?
Please help!
Thanks in advance!
Best Regards,
Jovan
Connecting To A Remote SQL Server
I am using a DSN-less connection to connect to a remote SQL Server hosted on the Internet.
Code:
Set cn = New ADODB.Connection
cn.Open "Driver={SQL Server};" & _
"Server=" & StrSQLServerName & ";" & _
"Address=" & StrSQLServerIPAddress & ",1433;" & _
"Network=DBMSSOCN;" & _
"Database=MyDatabaseName;" & _
"Uid=" & StrSQLUserID & ";" & _
"Pwd=" & StrSQLPassword
The problem is that since the SQL server is hosted on a DHCP server, it does not have a static IP address. In such a scene where I cannot afford a static IP for an Internet-hosted SQL server, how can I change my connection string to connect to the SQL Server? What other means do I have to connect to the SQL Server?
Run A Program In Remote Server
Hi All,
I need this help for my project.I want to run a program in remote server by passing two parameters each time it is called.One is a design number and the other is the process id.
Right now I am doing it by activating a terminal emulater and passing the program name and the parameters.
I am able to do this by activating the terminal emulater by AppActivate comand and then passing the statement by sendkeys.
The problem is if I minimise the terminal emulater window then the AppActivate statement does not work and I am not able to pass the statement.
Please advice if there is some way either to maximise the window after activating it through AppActivate.
Or
Please advice if there is some way by which I can execute the statement by using FTP rather then using the terminal emulater.
Thanks in Advance
Abhishek...
[Cimperiali: title changed to match the request]
Connecting To Remote SQL Server
'Ello, been messing with this for a long while now, and i'm stumped. I'm wanting to connect to a database on SQL server with my app from a remote machine on the net.
I looked thru the ADO Conn string, and this is what I have been messing around with.
Code:
oConn.Open "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Initial Catalog=myDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword"
Is this what I should be using? Also do I have to setup on my database something that allows outside IP #'s to connect and access the data?
Any help is appreciated. Thanks a bunch.
--Val
Remote ODBC On Server
I am having a hard time figuring out how to connect to a ODBC server over the internet can any one Help.
The database is MS Access.
Thanks in Advance.
Donny S.
Cannot Connect To Remote SQL Server
Hello!!
Someone plz help me....
I want to connect to remote SQL server....i m using this connection string
DCN_M = "Provider=SQLOLEDB;Data Source=xxx.xxx.xxx.xxx;Persist Security Info=False;User ID=myid ;Password=mypwd ;Initial Catalog=mydbname;"
SQLQuery = "Select fieldname from Tablename"
Set rs = New ADODB.Recordset
rs.Open SQLQuery, DCN_M, 1, 2
but i get an error message
runtime error -2147467259(80004005)
[DBNMPNTW]Specified sql server not found
but when the same program is run on another pc in the Lan it runs fine...this pc uses windows 2000 and my pc uses win 98....but i dont think that shd make a difference...
Alpa
|
TRACKER
